Required skills
analytical skills to:
analyse game application domain and game architecture and determine appropriate APIs as prescribed by the selected proprietary or database industry standards
determine appropriate connection pooling implementation requirements
determine appropriate development environments for the game architecture and database integration functionality
communication skills to:
describe and evaluate data access and data modification architectures with game designers and game architects
negotiate game data requirements with project managers, game designers and game architects
propose data access and modify functionality to meet the needs of the online game
initiative and enterprise skills to:
assess proposed database integration architectures within the context of existing game development technologies, development infrastructure and game industry standards
recommend solutions to difficulties or flaws identified with the integration of the database and the online game
learning skills to:
acquire the skills and knowledge required to integrate a database with an online game
ensure the use of leading edge industry developments and industry standards
literacy skills to:
delineate existing game architecture documentation
document database integration specifications for an online game
interpret and understand industry standards, game architecture standards, and database standards
planning and organisational skills:
organise resources, documentation and infrastructure elements required for the integration of a database with an online game
plan the effective integration of a database with an online game
problem-solving skills to:
debug code, identify code bugs and resolve all code exceptions
identify and implement solutions to problems with the integration of a database with an online game
identify problems with SQL and stored procedures and implement solutions
research skills to:
enhance knowledge of industry standards and trends related to the integration of a database with an online game
identify and locate sources of information that provide solutions to technical problems
identify sources of information and documentation required to plan and implement the integration of a database with an online game
technical skills to:
implement complex code algorithms required for the integration of a database with an online game
implement exception handling routines in code
improve the efficiency of code by refactoring
use an integrated development environment to build database integration code
write code to integrate a database with an online game.
Required knowledge
relational database theory, including:
how to create and test stored procedures
how to create ‘embedded’ SQL and assign parameters in code for filtering
how and why tables are related and how relationships between tables are implemented
how SQL is used to retrieve data from multiple tables
how inserts to tables in parent/child relationships can be implemented using artificial (auto-generated) primary key values
how to implement cascading updates and deletes
game development
integrated development environments, including:
data access APIs and associated classes required for the integration of a database with an online game
online help and documentation required for research and debugging code
user authentication and authorisation management
methodologies and techniques required for effective and well-factored object-oriented program (OOP) code, including:
class implementation
control of logic flow
use of collections and lists
use of OOP concepts, such as inheritance, encapsulation and overloading
web development.